Overview
Dataset statistics
| Number of variables | 8 |
|---|---|
| Number of observations | 768 |
| Missing cells | 1758 |
| Missing cells (%) | 28.6% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 72.0 KiB |
| Average record size in memory | 96.0 B |
Variable types
| Numeric | 6 |
|---|---|
| Unsupported | 2 |
hdl_cholesterol_mmol_L_consolidated is highly overall correlated with total_cholesterol_mmol_L | High correlation |
ldl_cholesterol_mmol_L_consolidated is highly overall correlated with total_cholesterol_mmol_L | High correlation |
total_cholesterol_mmol_L is highly overall correlated with hdl_cholesterol_mmol_L_consolidated and 1 other fields | High correlation |
Age (at enrolment) has 14 (1.8%) missing values | Missing |
Sex has 768 (100.0%) missing values | Missing |
study_week has 768 (100.0%) missing values | Missing |
total_cholesterol_mmol_L has 59 (7.7%) missing values | Missing |
hdl_cholesterol_mmol_L_consolidated has 58 (7.6%) missing values | Missing |
ldl_cholesterol_mmol_L_consolidated has 58 (7.6%) missing values | Missing |
fasting_glucose_mmol_L has 32 (4.2%) missing values | Missing |
Sex is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
study_week is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Reproduction
| Analysis started | 2025-11-25 06:48:37.976976 |
|---|---|
| Analysis finished | 2025-11-25 06:48:39.616998 |
| Duration | 1.64 second |
| Software version | ydata-profiling vv4.18.0 |
| Download configuration | config.json |
Variables
Age (at enrolment)
Real number (ℝ)
Missing
| Distinct | 183 |
|---|---|
| Distinct (%) | 24.3% |
| Missing | 14 |
| Missing (%) | 1.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 33.533554 |
| Minimum | 18.1 |
|---|---|
| Maximum | 51 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.0 KiB |
Quantile statistics
| Minimum | 18.1 |
|---|---|
| 5-th percentile | 22 |
| Q1 | 27.85 |
| median | 33.95 |
| Q3 | 39 |
| 95-th percentile | 46 |
| Maximum | 51 |
| Range | 32.9 |
| Interquartile range (IQR) | 11.15 |
Descriptive statistics
| Standard deviation | 7.3527855 |
|---|---|
| Coefficient of variation (CV) | 0.21926651 |
| Kurtosis | -0.80768914 |
| Mean | 33.533554 |
| Median Absolute Deviation (MAD) | 5.95 |
| Skewness | 0.055500259 |
| Sum | 25284.3 |
| Variance | 54.063454 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 40 | 32 | 4.2% |
| 34 | 31 | 4.0% |
| 39 | 31 | 4.0% |
| 37 | 29 | 3.8% |
| 30 | 27 | 3.5% |
| 31 | 25 | 3.3% |
| 38 | 23 | 3.0% |
| 41 | 22 | 2.9% |
| 26 | 21 | 2.7% |
| 35 | 21 | 2.7% |
| Other values (173) | 492 |
| Value | Count | Frequency (%) |
| 18.1 | 1 | 0.1% |
| 18.8 | 1 | 0.1% |
| 19 | 3 | 0.4% |
| 19.3 | 1 | 0.1% |
| 19.4 | 2 | 0.3% |
| 19.5 | 1 | 0.1% |
| 19.6 | 1 | 0.1% |
| 20 | 9 | |
| 20.1 | 1 | 0.1% |
| 20.6 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 51 | 1 | 0.1% |
| 50 | 3 | 0.4% |
| 49.1 | 1 | 0.1% |
| 49 | 5 | |
| 48 | 8 | |
| 47.9 | 1 | 0.1% |
| 47.2 | 1 | 0.1% |
| 47 | 10 | |
| 46.6 | 1 | 0.1% |
| 46.4 | 1 | 0.1% |
Sex
Unsupported
Missing Rejected Unsupported
| Missing | 768 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 12.0 KiB |
BMI (kg/m²)
Real number (ℝ)
| Distinct | 248 |
|---|---|
| Distinct (%) | 32.3% |
| Missing | 1 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 27.852803 |
| Minimum | 15.1 |
|---|---|
| Maximum | 57 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.0 KiB |
Quantile statistics
| Minimum | 15.1 |
|---|---|
| 5-th percentile | 19.13 |
| Q1 | 23 |
| median | 26.7 |
| Q3 | 31.5 |
| 95-th percentile | 40.54 |
| Maximum | 57 |
| Range | 41.9 |
| Interquartile range (IQR) | 8.5 |
Descriptive statistics
| Standard deviation | 6.6900116 |
|---|---|
| Coefficient of variation (CV) | 0.24019168 |
| Kurtosis | 1.6551874 |
| Mean | 27.852803 |
| Median Absolute Deviation (MAD) | 4.1 |
| Skewness | 1.0682353 |
| Sum | 21363.1 |
| Variance | 44.756255 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 26.3 | 11 | 1.4% |
| 25 | 10 | 1.3% |
| 21.8 | 10 | 1.3% |
| 26.7 | 9 | 1.2% |
| 27.4 | 8 | 1.0% |
| 25.8 | 8 | 1.0% |
| 32.3 | 8 | 1.0% |
| 21.5 | 8 | 1.0% |
| 22.9 | 8 | 1.0% |
| 28.9 | 7 | 0.9% |
| Other values (238) | 680 |
| Value | Count | Frequency (%) |
| 15.1 | 1 | |
| 15.3 | 1 | |
| 16 | 1 | |
| 16.1 | 1 | |
| 16.6 | 1 | |
| 16.8 | 1 | |
| 16.9 | 1 | |
| 17.1 | 1 | |
| 17.2 | 1 | |
| 17.3 | 1 |
| Value | Count | Frequency (%) |
| 57 | 1 | 0.1% |
| 56.1 | 1 | 0.1% |
| 54.9 | 1 | 0.1% |
| 54.3 | 1 | 0.1% |
| 50.7 | 1 | 0.1% |
| 50.4 | 1 | 0.1% |
| 50.1 | 1 | 0.1% |
| 49.8 | 3 | |
| 49 | 1 | 0.1% |
| 46.4 | 2 |
study_week
Unsupported
Missing Rejected Unsupported
| Missing | 768 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 12.0 KiB |
total_cholesterol_mmol_L
Real number (ℝ)
High correlation Missing
| Distinct | 331 |
|---|---|
| Distinct (%) | 46.7% |
| Missing | 59 |
| Missing (%) | 7.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.1249083 |
| Minimum | 1.12 |
|---|---|
| Maximum | 10.48 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.0 KiB |
Quantile statistics
| Minimum | 1.12 |
|---|---|
| 5-th percentile | 2.538 |
| Q1 | 3.39 |
| median | 4 |
| Q3 | 4.81 |
| 95-th percentile | 6.016 |
| Maximum | 10.48 |
| Range | 9.36 |
| Interquartile range (IQR) | 1.42 |
Descriptive statistics
| Standard deviation | 1.1613229 |
|---|---|
| Coefficient of variation (CV) | 0.28153907 |
| Kurtosis | 3.3551237 |
| Mean | 4.1249083 |
| Median Absolute Deviation (MAD) | 0.7 |
| Skewness | 1.0133115 |
| Sum | 2924.56 |
| Variance | 1.3486708 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 4 | 10 | 1.3% |
| 4.11 | 9 | 1.2% |
| 3.62 | 7 | 0.9% |
| 4.57 | 6 | 0.8% |
| 3.89 | 6 | 0.8% |
| 3.48 | 6 | 0.8% |
| 4.93 | 6 | 0.8% |
| 3.68 | 6 | 0.8% |
| 2.77 | 5 | 0.7% |
| 3.52 | 5 | 0.7% |
| Other values (321) | 643 | |
| (Missing) | 59 | 7.7% |
| Value | Count | Frequency (%) |
| 1.12 | 1 | |
| 1.22 | 1 | |
| 1.29 | 1 | |
| 1.38 | 1 | |
| 1.54 | 1 | |
| 1.59 | 1 | |
| 1.8 | 2 | |
| 1.85 | 1 | |
| 2.01 | 2 | |
| 2.06 | 1 |
| Value | Count | Frequency (%) |
| 10.48 | 1 | |
| 10.29 | 1 | |
| 9.28 | 2 | |
| 9.04 | 1 | |
| 8.65 | 1 | |
| 7.7 | 1 | |
| 7.59 | 1 | |
| 7.3 | 1 | |
| 7.28 | 1 | |
| 6.82 | 1 |
hdl_cholesterol_mmol_L_consolidated
Real number (ℝ)
High correlation Missing
| Distinct | 174 |
|---|---|
| Distinct (%) | 24.5% |
| Missing | 58 |
| Missing (%) | 7.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.1211127 |
| Minimum | 0.28 |
|---|---|
| Maximum | 3.7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.0 KiB |
Quantile statistics
| Minimum | 0.28 |
|---|---|
| 5-th percentile | 0.51 |
| Q1 | 0.83 |
| median | 1.07 |
| Q3 | 1.37 |
| 95-th percentile | 1.8855 |
| Maximum | 3.7 |
| Range | 3.42 |
| Interquartile range (IQR) | 0.54 |
Descriptive statistics
| Standard deviation | 0.44352229 |
|---|---|
| Coefficient of variation (CV) | 0.39560902 |
| Kurtosis | 4.4712255 |
| Mean | 1.1211127 |
| Median Absolute Deviation (MAD) | 0.26 |
| Skewness | 1.2913394 |
| Sum | 795.99 |
| Variance | 0.19671202 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.8 | 13 | 1.7% |
| 1.04 | 13 | 1.7% |
| 0.85 | 13 | 1.7% |
| 0.93 | 13 | 1.7% |
| 1.1 | 13 | 1.7% |
| 1.18 | 11 | 1.4% |
| 0.95 | 11 | 1.4% |
| 1 | 10 | 1.3% |
| 0.84 | 10 | 1.3% |
| 0.87 | 9 | 1.2% |
| Other values (164) | 594 | |
| (Missing) | 58 | 7.6% |
| Value | Count | Frequency (%) |
| 0.28 | 1 | |
| 0.32 | 1 | |
| 0.33 | 2 | |
| 0.34 | 2 | |
| 0.35 | 1 | |
| 0.36 | 2 | |
| 0.37 | 2 | |
| 0.39 | 1 | |
| 0.4 | 2 | |
| 0.41 | 2 |
| Value | Count | Frequency (%) |
| 3.7 | 3 | |
| 2.8 | 1 | 0.1% |
| 2.53 | 2 | |
| 2.49 | 1 | 0.1% |
| 2.44 | 1 | 0.1% |
| 2.31 | 1 | 0.1% |
| 2.3 | 1 | 0.1% |
| 2.29 | 1 | 0.1% |
| 2.24 | 2 | |
| 2.23 | 1 | 0.1% |
ldl_cholesterol_mmol_L_consolidated
Real number (ℝ)
High correlation Missing
| Distinct | 261 |
|---|---|
| Distinct (%) | 36.8% |
| Missing | 58 |
| Missing (%) | 7.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.6717042 |
| Minimum | 0 |
|---|---|
| Maximum | 6.04 |
| Zeros | 1 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.6745 |
| Q1 | 1.11 |
| median | 1.535 |
| Q3 | 2.07 |
| 95-th percentile | 3.18 |
| Maximum | 6.04 |
| Range | 6.04 |
| Interquartile range (IQR) | 0.96 |
Descriptive statistics
| Standard deviation | 0.77008108 |
|---|---|
| Coefficient of variation (CV) | 0.4606563 |
| Kurtosis | 1.8978142 |
| Mean | 1.6717042 |
| Median Absolute Deviation (MAD) | 0.475 |
| Skewness | 1.0866871 |
| Sum | 1186.91 |
| Variance | 0.59302488 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1.01 | 9 | 1.2% |
| 1.12 | 9 | 1.2% |
| 1.32 | 9 | 1.2% |
| 1.37 | 8 | 1.0% |
| 1.29 | 8 | 1.0% |
| 1.18 | 7 | 0.9% |
| 2.06 | 7 | 0.9% |
| 1.94 | 7 | 0.9% |
| 1.26 | 7 | 0.9% |
| 1.76 | 7 | 0.9% |
| Other values (251) | 632 | |
| (Missing) | 58 | 7.6% |
| Value | Count | Frequency (%) |
| 0 | 1 | 0.1% |
| 0.33 | 1 | 0.1% |
| 0.39 | 1 | 0.1% |
| 0.42 | 2 | 0.3% |
| 0.45 | 1 | 0.1% |
| 0.46 | 1 | 0.1% |
| 0.47 | 1 | 0.1% |
| 0.5 | 3 | |
| 0.55 | 5 | |
| 0.56 | 4 |
| Value | Count | Frequency (%) |
| 6.04 | 1 | |
| 4.41 | 1 | |
| 4.28 | 1 | |
| 4.25 | 2 | |
| 4.19 | 1 | |
| 4.13 | 1 | |
| 3.97 | 1 | |
| 3.94 | 1 | |
| 3.89 | 1 | |
| 3.87 | 1 |
fasting_glucose_mmol_L
Real number (ℝ)
Missing
| Distinct | 276 |
|---|---|
| Distinct (%) | 37.5% |
| Missing | 32 |
| Missing (%) | 4.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.928356 |
| Minimum | 0.95 |
|---|---|
| Maximum | 15 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.0 KiB |
Quantile statistics
| Minimum | 0.95 |
|---|---|
| 5-th percentile | 3.35 |
| Q1 | 4.5 |
| median | 4.93 |
| Q3 | 5.4125 |
| 95-th percentile | 6.12 |
| Maximum | 15 |
| Range | 14.05 |
| Interquartile range (IQR) | 0.9125 |
Descriptive statistics
| Standard deviation | 0.95305831 |
|---|---|
| Coefficient of variation (CV) | 0.1933826 |
| Kurtosis | 19.566982 |
| Mean | 4.928356 |
| Median Absolute Deviation (MAD) | 0.45 |
| Skewness | 1.5235001 |
| Sum | 3627.27 |
| Variance | 0.90832015 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 5.21 | 9 | 1.2% |
| 4.75 | 9 | 1.2% |
| 5.42 | 8 | 1.0% |
| 4.82 | 8 | 1.0% |
| 4.93 | 8 | 1.0% |
| 4.7 | 8 | 1.0% |
| 5.24 | 8 | 1.0% |
| 4.73 | 7 | 0.9% |
| 4.57 | 7 | 0.9% |
| 5.17 | 7 | 0.9% |
| Other values (266) | 657 | |
| (Missing) | 32 | 4.2% |
| Value | Count | Frequency (%) |
| 0.95 | 1 | |
| 1.12 | 1 | |
| 1.37 | 1 | |
| 1.47 | 1 | |
| 2.02 | 1 | |
| 2.04 | 1 | |
| 2.21 | 1 | |
| 2.22 | 1 | |
| 2.26 | 1 | |
| 2.55 | 2 |
| Value | Count | Frequency (%) |
| 15 | 1 | |
| 9.91 | 1 | |
| 9.67 | 1 | |
| 8.24 | 1 | |
| 7.97 | 1 | |
| 7.62 | 1 | |
| 7.61 | 1 | |
| 7.42 | 1 | |
| 7.27 | 1 | |
| 7.06 | 1 |
Interactions
Correlations
| Age (at enrolment) | BMI (kg/m²) | fasting_glucose_mmol_L | hdl_cholesterol_mmol_L_consolidated | ldl_cholesterol_mmol_L_consolidated | total_cholesterol_mmol_L | |
|---|---|---|---|---|---|---|
| Age (at enrolment) | 1.000 | 0.229 | 0.154 | 0.012 | 0.157 | 0.155 |
| BMI (kg/m²) | 0.229 | 1.000 | 0.116 | 0.020 | 0.106 | 0.096 |
| fasting_glucose_mmol_L | 0.154 | 0.116 | 1.000 | 0.008 | 0.032 | -0.066 |
| hdl_cholesterol_mmol_L_consolidated | 0.012 | 0.020 | 0.008 | 1.000 | 0.269 | 0.507 |
| ldl_cholesterol_mmol_L_consolidated | 0.157 | 0.106 | 0.032 | 0.269 | 1.000 | 0.566 |
| total_cholesterol_mmol_L | 0.155 | 0.096 | -0.066 | 0.507 | 0.566 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
Sample
| Age (at enrolment) | Sex | BMI (kg/m²) | study_week | total_cholesterol_mmol_L | hdl_cholesterol_mmol_L_consolidated | ldl_cholesterol_mmol_L_consolidated | fasting_glucose_mmol_L | |
|---|---|---|---|---|---|---|---|---|
| 217 | 19.4 | NaN | 24.2 | NaN | 2.77 | 1.23 | 1.41 | 5.03 |
| 218 | 39.4 | NaN | 33.6 | NaN | 4.93 | 0.90 | 1.54 | 4.55 |
| 219 | NaN | NaN | 33.1 | NaN | 5.11 | 1.33 | 2.20 | 4.76 |
| 220 | 40.0 | NaN | 33.5 | NaN | 5.35 | 1.61 | 2.37 | 6.72 |
| 221 | 42.0 | NaN | 30.1 | NaN | 5.89 | 1.71 | 3.36 | 5.68 |
| 222 | 39.0 | NaN | 22.0 | NaN | 3.97 | 1.16 | 3.03 | 5.03 |
| 223 | 40.0 | NaN | 21.5 | NaN | 2.52 | 0.52 | 2.48 | 4.32 |
| 224 | 40.0 | NaN | 21.2 | NaN | 4.17 | 0.95 | 2.71 | 5.48 |
| 225 | 41.0 | NaN | 21.6 | NaN | 4.47 | 1.04 | 2.60 | 5.26 |
| 226 | 22.2 | NaN | 19.3 | NaN | 3.13 | 0.90 | 2.17 | 4.25 |
| Age (at enrolment) | Sex | BMI (kg/m²) | study_week | total_cholesterol_mmol_L | hdl_cholesterol_mmol_L_consolidated | ldl_cholesterol_mmol_L_consolidated | fasting_glucose_mmol_L | |
|---|---|---|---|---|---|---|---|---|
| 975 | 25.9 | NaN | 21.5 | NaN | 4.96 | 1.14 | 1.57 | 4.76 |
| 976 | NaN | NaN | 22.6 | NaN | 6.24 | 1.32 | 2.19 | 4.97 |
| 977 | 27.0 | NaN | 23.6 | NaN | 6.82 | 1.96 | 2.68 | NaN |
| 978 | 33.3 | NaN | 32.4 | NaN | 3.70 | 1.10 | 1.05 | 5.38 |
| 979 | 34.0 | NaN | 34.4 | NaN | 5.32 | 1.40 | 1.72 | 5.50 |
| 980 | 34.0 | NaN | 37.3 | NaN | 4.11 | 1.76 | 1.32 | 5.99 |
| 981 | 35.0 | NaN | 37.9 | NaN | 2.35 | 0.42 | 1.35 | 6.11 |
| 982 | 31.3 | NaN | 31.8 | NaN | 3.52 | 0.91 | 1.00 | 5.21 |
| 983 | 32.0 | NaN | 31.2 | NaN | 2.93 | 1.02 | 0.59 | 4.67 |
| 984 | 32.0 | NaN | 33.2 | NaN | NaN | NaN | NaN | 5.76 |